const { app, BrowserWindow, Menu, ipcMain, dialog } = require('electron');
const path = require('path');
const xlsx = require('node-xlsx');
const writeDb = require('./tool/save-data');


// Handle creating/removing shortcuts on Windows when installing/uninstalling.
if (require('electron-squirrel-startup')) { // eslint-disable-line global-require
    app.quit();
}

ipcMain.on('asynchronous-message', function(event, arg) {
    // arg是从渲染进程返回来的数据
    dialog.showOpenDialog(arg).then(result => {
        // console.log(result.canceled)
        // console.log(result.filePaths)

        let sheets = xlsx.parse(result.filePaths[0]);
        // console.log(sheets);
        // for (let row of sheets[0].data) {
        //     console.log(row);
        // }

        let datas = [];
        for (let index = 1; index < sheets[0].data.length; index++) {
            let row = sheets[0].data[index];
            let record = {
                id: new Date().getTime(),
                user_name: row[1],
                score: row[2] ? row[2] : 0,
                create_date: new Date().toLocaleDateString()
            };

            datas.push(record);
        }

        // writeDb(datas);

        event.sender.send('asynchronous-reply', { fileName: result.filePaths[0], datas: sheets[0].data });

    }).catch(err => {
        console.log(err)
        event.sender.send('asynchronous-reply', "读取失败");
    })
});

const createWindow = () => {
    // Menu.setApplicationMenu(null);

    // Create the browser window.
    const mainWindow = new BrowserWindow({
        width: 1200,
        height: 800,
        webPreferences: {
            preload: path.join(__dirname, 'preload.js'),
            // enableRemoteModule: true,
            // nodeIntegration: true,
        }
    });

    // and load the index.html of the app.
    mainWindow.loadFile(path.join(__dirname, 'index.html'));

    // Open the DevTools.
    mainWindow.webContents.openDevTools();
};

// This method will be called when Electron has finished
// initialization and is ready to create browser windows.
// Some APIs can only be used after this event occurs.
app.on('ready', createWindow);

// Quit when all windows are closed, except on macOS. There, it's common
// for applications and their menu bar to stay active until the user quits
// explicitly with Cmd + Q.
app.on('window-all-closed', () => {
    if (process.platform !== 'darwin') {
        app.quit();
    }
});

app.on('activate', () => {
    // On OS X it's common to re-create a window in the app when the
    // dock icon is clicked and there are no other windows open.
    if (BrowserWindow.getAllWindows().length === 0) {
        createWindow();
    }
});

// In this file you can include the rest of your app's specific main process
// code. You can also put them in separate files and import them here.